package cn.kgc.mapper;

import cn.kgc.bean.pojo.EpStaff;
import org.apache.ibatis.annotations.Param;
/*
 *@author zhangtao
 *@Date 2023/4/27
 */
import java.util.List;

public interface EpStaffMapper {

    /*
     *@author wangchangsheng
     *@Date 2023/4/27
     * 人员管理(分页查询)
     */
    List<EpStaff> getAllInfoEpStaff();

    /*
     *@author wangchangsheng
     *@Date 2023/4/28
     * 人员管理(模糊查询)
     */
    List<EpStaff> getEpStaffByAgeAndGenderAndEducationAndDepartment(@Param("age")Integer age,
                                                                    @Param("gender")String gender,
                                                                    @Param("education")String education,
                                                                    @Param("department")String department,
                                                                    @Param("staffId")String staffId,
                                                                    @Param("name")String name);


    /*
     *@author wangchangsheng
     *@Date 2023/4/27
     * 人员录入(员工录入)
     */
    int addEpStaff(EpStaff epStaff);

    /*
     *@author wangchangsheng
     *@Date 2023/4/28
     * 人员录入(修改信息)
     */
    int updateEpStaff(EpStaff epStaff);


    /*
     *@author wangchangsheng
     *@Date 2023/4/28
     * 人员管理(员工删除)
     */
    int delEpStaff(@Param("id") Long id);



    /**
     * @description 查询人员违章情况
     * @author panchongxin
     * @param :
     * @return List<EpStaff>
     * @date 2023/5/5 14:32
     */
    List<EpStaff> showStaffInfo(@Param("age")Integer age,
                                @Param("gender")String gender,
                                @Param("education")String education,
                                @Param("department")String department);

    /**
     * @description 根据员工编号修改员工安全培训分数
     * @author panchongxin
     * @param staffId:
     * @return int
     * @date 2023/5/6 9:50
     */
    int updateScoreByStaffId(@Param("staffId")String staffId,@Param("score")Integer score);
}
